SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [GOOGLECODERS].[Postnet](
	[IdPostnet] [int] Primary key Identity(1,1),
	[Modelo] [varchar](50) COLLATE Modern_Spanish_CI_AS NOT NULL,
	[Marca] [varchar](255) COLLATE Modern_Spanish_CI_AS NOT NULL,
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

SET IDENTITY_INSERT [GOOGLECODERS].[Postnet] ON
INSERT INTO [GD2C2011].[GOOGLECODERS].[Postnet]
           ( [IdPostnet]
			,[Modelo]
			,[Marca]
			)  
	
SELECT DISTINCT 
	   [POSTNET_NRO_SERIE]
      ,[POSTNET_MODELO]
	  ,RTRIM([POSTNET_MARCA])
  FROM [GD2C2011].[gd_eschema].[Maestra]
WHERE POSTNET_NRO_SERIE <> 0

SET IDENTITY_INSERT [GOOGLECODERS].[Postnet] OFF